<?php

use yii\db\Migration;

class m231104_123105_diandi_mall_order_goods extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%diandi_mall_order_goods}}', [
            'order_goods_id' => "int(11) unsigned NOT NULL AUTO_INCREMENT",
            'bloc_id' => "int(11) NULL",
            'store_id' => "int(255) NULL",
            'goods_type' => "int(11) NULL",
            'goods_id' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'goods_name' => "varchar(255) NOT NULL DEFAULT ''",
            'thumb' => "varchar(255) NOT NULL DEFAULT '0'",
            'stock_up' => "int(11) NULL DEFAULT '0' COMMENT '库存是否处理'",
            'deduct_stock_type' => "tinyint(3) unsigned NULL DEFAULT '20'",
            'spec_type' => "tinyint(3) unsigned NULL DEFAULT '0'",
            'spec_sku_id' => "varchar(255) NULL DEFAULT ''",
            'goods_spec_id' => "int(11) unsigned NULL DEFAULT '0'",
            'goods_attr' => "varchar(500) NULL DEFAULT ''",
            'content' => "longtext NULL",
            'goods_no' => "varchar(100) NULL DEFAULT ''",
            'performance' => "decimal(11,3) NULL COMMENT '礼包业绩'",
            'goods_price' => "decimal(10,2) unsigned NULL",
            'line_price' => "decimal(10,2) unsigned NOT NULL",
            'goods_weight' => "double unsigned NOT NULL DEFAULT '0'",
            'total_num' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'total_price' => "decimal(10,2) unsigned NOT NULL",
            'order_id' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'user_id' => "int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下单人'",
            'wxapp_id' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'remark' => "varchar(255) NULL",
            'goods_costprice' => "decimal(10,2) NULL",
            'is_rebate' => "int(11) NULL DEFAULT '0'",
            'create_time' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'update_time' => "int(11) NULL",
            'PRIMARY KEY (`order_goods_id`)'
        ], "ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC");
        
        /* 索引设置 */
        
        
        /* 表数据 */
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'1','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'商品1','thumb'=>'https://www.dandicloud.cn/attachment/202207/13/b28623e0-ccf2-3ccf-949d-57e384873da7.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>1</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'1','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1657695844','update_time'=>'1657695844']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'2','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'商品1','thumb'=>'https://www.dandicloud.cn/attachment/202207/13/b28623e0-ccf2-3ccf-949d-57e384873da7.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'0','spec_sku_id'=>'1','goods_spec_id'=>'2','goods_attr'=>'规格1','content'=>'<p>1</p>','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'2','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1657778846','update_time'=>'1657778846']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'3','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'商品1','thumb'=>'https://www.dandicloud.cn/attachment/202207/13/b28623e0-ccf2-3ccf-949d-57e384873da7.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'0','spec_sku_id'=>'1','goods_spec_id'=>'2','goods_attr'=>'规格1','content'=>'<p>1</p>','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'3','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1657784436','update_time'=>'1657784436']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'4','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'0','spec_sku_id'=>'1','goods_spec_id'=>'2','goods_attr'=>'规格1','content'=>'<p>1</p>','goods_no'=>'1','performance'=>NULL,'goods_price'=>'2.00','line_price'=>'1.00','goods_weight'=>'22','total_num'=>'1','total_price'=>'2.00','order_id'=>'4','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'12.00','is_rebate'=>'0','create_time'=>'1657838140','update_time'=>'1657838140']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'5','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'10','goods_name'=>'测试商品','thumb'=>'https://www.dandicloud.cn/attachment/202207/19/6881249e-acdf-395c-b4ae-50ce2982dc6c.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>1</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'499.00','line_price'=>'499.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'499.00','order_id'=>'5','user_id'=>'10','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'499.00','is_rebate'=>'0','create_time'=>'1658224513','update_time'=>'1658224513']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'6','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'2','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'2.00','line_price'=>'2.00','goods_weight'=>'22','total_num'=>'1','total_price'=>'2.00','order_id'=>'6','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658389409','update_time'=>'1658389409']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'7','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'10','goods_name'=>'测试商品','thumb'=>'https://www.dandicloud.cn/attachment/202207/19/6881249e-acdf-395c-b4ae-50ce2982dc6c.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'499.00','line_price'=>'499.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'499.00','order_id'=>'6','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'499.00','is_rebate'=>'0','create_time'=>'1658389409','update_time'=>'1658389409']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'8','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/acd191bd-2e73-3a70-9e23-6f9007566788.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'6','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658389409','update_time'=>'1658389409']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'9','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'2','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'2.00','line_price'=>'2.00','goods_weight'=>'22','total_num'=>'1','total_price'=>'2.00','order_id'=>'7','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658398650','update_time'=>'1658398650']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'10','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'2','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'2.00','line_price'=>'2.00','goods_weight'=>'22','total_num'=>'1','total_price'=>'2.00','order_id'=>'8','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658398689','update_time'=>'1658398689']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'11','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'9','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658816892','update_time'=>'1658816892']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'12','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'10','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658817492','update_time'=>'1658817492']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'13','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'11','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658819634','update_time'=>'1658819634']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'14','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>2</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'12','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658820776','update_time'=>'1658820776']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'15','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'6','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'13','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658824610','update_time'=>'1658824610']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'16','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'6','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'14','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658830611','update_time'=>'1658830611']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'17','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'6','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'15','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658831775','update_time'=>'1658831775']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'18','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'1','goods_name'=>'智能门锁','thumb'=>'https://www.dandicloud.cn/attachment/202207/14/c4a9ee33-3441-346d-b1ae-1dcbc0ec0f28.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>'6','goods_attr'=>NULL,'content'=>'rr','goods_no'=>'1','performance'=>NULL,'goods_price'=>'1.00','line_price'=>'1.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'1.00','order_id'=>'16','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1.00','is_rebate'=>'0','create_time'=>'1658832404','update_time'=>'1658832404']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'19','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'17','user_id'=>'2','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1658832798','update_time'=>'1658832798']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'20','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>2</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'12.00','line_price'=>'23.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'12.00','order_id'=>'18','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'3.00','is_rebate'=>'0','create_time'=>'1659007408','update_time'=>'1659007408']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'41','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'13','goods_name'=>'店滴云品牌代理','thumb'=>'https://www.dandicloud.cn/attachment/202207/28/2d6cbe23-32f6-3fb3-843e-ced03e13e514.png','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>1</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'999.00','line_price'=>'1999.00','goods_weight'=>'1','total_num'=>'1','total_price'=>'999.00','order_id'=>'39','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'699.00','is_rebate'=>'0','create_time'=>'1659259799','update_time'=>'1659259799']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'103','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>2</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'499.00','line_price'=>'1499.00','goods_weight'=>'2','total_num'=>'10','total_price'=>'4990.00','order_id'=>'101','user_id'=>'15','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'2990.00','is_rebate'=>'0','create_time'=>'1659260427','update_time'=>'1659260427']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'107','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>2</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'499.00','line_price'=>'1499.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'499.00','order_id'=>'105','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'299.00','is_rebate'=>'0','create_time'=>'1659277496','update_time'=>'1659277496']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'110','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'5','goods_name'=>'店滴云商业授权','thumb'=>'https://www.dandicloud.cn/attachment/202207/22/9837219c-42b9-3fb7-be6a-48479b931d24.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>2</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'499.00','line_price'=>'1499.00','goods_weight'=>'2','total_num'=>'4','total_price'=>'1996.00','order_id'=>'108','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1196.00','is_rebate'=>'0','create_time'=>'1659529689','update_time'=>'1659529689']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'111','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'4','total_price'=>'1596.00','order_id'=>'109','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'1596.00','is_rebate'=>'0','create_time'=>'1659529714','update_time'=>'1659529714']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'154','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'399.00','order_id'=>'152','user_id'=>'15','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'399.00','is_rebate'=>'0','create_time'=>'1661356656','update_time'=>'1661356656']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'155','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>NULL,'goods_spec_id'=>NULL,'goods_attr'=>NULL,'content'=>'rr','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'30','total_price'=>'11970.00','order_id'=>'153','user_id'=>'15','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'11970.00','is_rebate'=>'0','create_time'=>'1661356717','update_time'=>'1661356717']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'156','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'12','total_price'=>'4788.00','order_id'=>'154','user_id'=>'15','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'4788.00','is_rebate'=>'0','create_time'=>'1664156945','update_time'=>'1664156945']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'157','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'2','total_price'=>'798.00','order_id'=>'155','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'798.00','is_rebate'=>'0','create_time'=>'1664527538','update_time'=>'1664527538']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'158','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'399.00','order_id'=>'156','user_id'=>'4','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'399.00','is_rebate'=>'0','create_time'=>'1664527588','update_time'=>'1664527588']);
        $this->insert('{{%diandi_mall_order_goods}}',['order_goods_id'=>'159','bloc_id'=>'13','store_id'=>'62','goods_type'=>'2','goods_id'=>'4','goods_name'=>'智能开关','thumb'=>'https://www.dandicloud.cn/attachment/202207/15/27a7006c-9814-3839-ac25-536b92498400.jpg','stock_up'=>'1','deduct_stock_type'=>'10','spec_type'=>'1','spec_sku_id'=>'','goods_spec_id'=>'0','goods_attr'=>NULL,'content'=>'<p>23</p>','goods_no'=>NULL,'performance'=>NULL,'goods_price'=>'399.00','line_price'=>'399.00','goods_weight'=>'2','total_num'=>'1','total_price'=>'399.00','order_id'=>'157','user_id'=>'29','wxapp_id'=>'0','remark'=>NULL,'goods_costprice'=>'399.00','is_rebate'=>'0','create_time'=>'1666010868','update_time'=>'1666010868']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%diandi_mall_order_goods}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

